Tabela NutritionResource

Definicja tabeli NutritionResource

Name

NutritionResource

Code

NutritionResource

Comment

Zasoby (substancje) wykorzystywane w zywieniu do/pozajelitowym


Lista kolumn tabeli NutritionResource

Name

Code

NutritionResourceID

NutritionResourceID

UnitID

UnitID

NutritionResourceGroupID

NutritionResourceGroupID

NutritionTypeID

NutritionTypeID

FullName

FullName

Active

Active

Code

Code

ShortName

ShortName

Description

Description


Kolumna NutritionResourceID tabeli NutritionResource

Definicja kolumny NutritionResourceID tabeli NutritionResource

Name

NutritionResourceID

Code

NutritionResourceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna UnitID tabeli NutritionResource

Definicja kolumny UnitID tabeli NutritionResource

Name

UnitID

Code

UnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NutritionResourceGroupID tabeli NutritionResource

Definicja kolumny NutritionResourceGroupID tabeli NutritionResource

Name

NutritionResourceGroupID

Code

NutritionResourceGroupID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NutritionTypeID tabeli NutritionResource

Definicja kolumny NutritionTypeID tabeli NutritionResource

Name

NutritionTypeID

Code

NutritionTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna FullName tabeli NutritionResource

Definicja kolumny FullName tabeli NutritionResource

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

 


Kolumna Active tabeli NutritionResource

Definicja kolumny Active tabeli NutritionResource

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

Yes

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Code tabeli NutritionResource

Definicja kolumny Code tabeli NutritionResource

Name

Code

Code

Code

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna ShortName tabeli NutritionResource

Definicja kolumny ShortName tabeli NutritionResource

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna Description tabeli NutritionResource

Definicja kolumny Description tabeli NutritionResource

Name

Description

Code

Description

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli NutritionResource

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli NutritionResource

Definicja klucza Identifier_1 tabeli NutritionResource

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment